Shwetajoel
New Member
- Joined
- Nov 24, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi, I am trying to create a conditional formatting where if the cell value in L2 is "waiting" whole row turns in Red colour and then I can use this condition for the entire table. I used (=$L2="Waiting")formula first but then its turning even the blank rows as red when I am dragging the formula down from L2 column as the value "waiting " is formula driven which is =IF(ISBLANK(H2),"Waiting",(IF(ISBLANK(AD405),"Current","Discharged"))) and its filling all the balnk columns with "waiting" even when all the rest of the columns in the entire rows are blank
I tried to change conditional formatting rule as IF(AND(ISBLANK($H2), $L2=”Waiting”)FALSE, TRUE) to base the red colour formatting based on one more cell value H2 which is in case H2 is not blank and L2 is "waiting" then the whole row turn into red colour but this is not working now.
Kindly help how can I achieve the red colour formatting without having the red colur filled in the blank rows.
I tried to change conditional formatting rule as IF(AND(ISBLANK($H2), $L2=”Waiting”)FALSE, TRUE) to base the red colour formatting based on one more cell value H2 which is in case H2 is not blank and L2 is "waiting" then the whole row turn into red colour but this is not working now.
Kindly help how can I achieve the red colour formatting without having the red colur filled in the blank rows.