conditional formatting across a row, based on value in a single ce

O

oaode

How can i format a whole row ( change the colour, font, fill) by using the
value in a single row to conditionally format it
 
B

Bob Phillips

In CF, change condition1 to Formula Is and use a formula like

=$A5=7
or whatever the formula is, just make sure that you absolute the column.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Changing row background from external program 0
Conditional Formatting question.... 1
Conditional formatting 3
Conditional formattion for whole row based on one cell value 3
Conditional Formatting Across Multiple Cells 0
Conditional Formating based on Data Validation 3
condition format 3
Copying Conditional Formatting 3

Top