Change the fill color of a cell as a result of EXACT

I use a simple form of error checking against an existing table within my spreadsheet; i.e. as the user inputs equipment ID's into part of the spreadsheet, I run a LOOKUP and EXACT function to compare the user's inputs against a known/correct table of equipment ID's.

Is there a way to change cell colors if the data entered by the user is correct data (TRUE according to the EXACT function)? This will be a simple visual cue that the ID is correct; I would like to add a check box that is checked under the same conditions.............

Will this require a little VBA?

Thanks,
ST

If you select the cells with those results

Then go to Format|Conditional Formatting

Choose Cell Value Is >> Equal to >> and enter =TRUE

Then click Format and choose from whatever tab you need...