Highlighting using Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
Perfect! Many thanks!

T. Valko said:
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
Click to expand...
 
Back
Top