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

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

Guest

How can i format a whole row ( change the colour, font, fill) by using the
value in a single row to conditionally format it
 
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)
 
You must log in or register to reply here.

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

Question about conditional formatting of zeros in Excel 0
Conditional formattion for whole row based on one cell value 3
Conditional Formating based on Data Validation 3
Conditional formatting 3
condition format 2
Copying Conditional Formatting 3
Excel Conditional Formatting 1
Can you conditionally format a whole row based on data in one cel 1

Back
Top