Highlighting using Conditional Formatting
 

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!

Highlighting using Conditional Formatting
 

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!

Highlighting using Conditional Formatting
 

Perfect! Many thanks!

"T. Valko" wrote:

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!

Highlighting using Conditional Formatting
 

You're welcome. Thanks for the feedback!

Biff

"SLW612" wrote in message
...
Perfect! Many thanks!

"T. Valko" wrote:

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!