Conditional Formatting

B

Bilbo

Hi all

Is it possible to use conditional formatting on a whole
row, based on a condition in one of its cells? If the
content of cell H3 is 'Temp' I want to shade the whole of
row 3 light grey, not just the cell with that word in it.
NB I already have conditional formatting on one fo the
columns, changing the format of individual cells if they
meet a particular criterion.
Have great weekends all you people out there!

Bilbo
 
B

Biff

Hi Bilbo,

Yes, you can do that.

Select the row by clicking the row number.
Conditional Format
Formula Is =$H$3="TEMP"
Select you style
OK out

You say that you already have some cells with conditional
formatting. Which ever CF you applied first will have
precedence.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 Conditional Formatting 2
conditional formatting update issue 5
conditionally formatting 3
Conditional format 1
Changing the color of rows - conditional formatting 3
Conditional Formating 6
copy conditional formatting range 3
help with Conditional formatting pairs of cells 1

Top