Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I format a row depending on the value of a cell in the row
I have a table set up and would like any row of the table where a particular
cell in the same row is blank to be highlighted. In other words, for any cell in column J that is blank, I want the corresponding row to be highlighted. I'm trying the conditional formating 'Formula Is' but so far it's not working for me. Any ideas? |
#2
|
|||
|
|||
Select the whole table, assume the table is A1:D10, so formula is should be
=COUNTBLANK($A1:$D1)0 replace A1 with the left uppermost cell in your table that you want to test for and D1 with the right uppermost cell, notice the mixed relative absolute references (dollar signs) regards, Peo Sjoblom "Kristine VA" wrote: I have a table set up and would like any row of the table where a particular cell in the same row is blank to be highlighted. In other words, for any cell in column J that is blank, I want the corresponding row to be highlighted. I'm trying the conditional formating 'Formula Is' but so far it's not working for me. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
Change decimal format of cells depending on conditions? | Excel Worksheet Functions |