Try this:

Assume the range in question is A1:C10

Select the range A1:C10
With A1 being the active cell (A1 is "clear" and all other cells in the
range have a "blueish color)
Goto the menu FormatConditional Formatting
Formula Is: =AND($C1=54,$C1<=200)
Click the Format button
Select the Patterns tab
Select a color of your choice
OK out

Biff

"SLW612" wrote in message
...
I have a 3-column spreadsheet that I want to run a formula to check column
3
for numbers between (and including) 54 and 200, and then highlight that
cell
along with the cells in that row. Example: if C5=60 then I would like A5
and B5 highlighted along with C5. Any assistance is helpful!

Thanks in advance!