Highlighting using Conditional Formatting

[Guest]

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!

 

[T. Valko]

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 Format>Conditional 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

 

[Guest]

Perfect! Many thanks!

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 Format>Conditional 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

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Perfect! Many thanks!