.:i think i thought a thought:.

Personal ramblings of Ritin Tandon - on technology, business, economy and life. A celebration of a neural synapse that I feel is worth sharing with the world.




Conditional row color based on a cell value

Select all the cells that need to be colored. Usually we color a cell based an its value and use the [Cell Value Is ] in the conditional formatting box. To format cells based on other cells you need the [Cell Formula Is].
We use the =INDIRECT() function to get the value of column C for each row:
If the value is TRUE : =INDIRECT("C"&ROW())=TRUE
If the value is 1 : =INDIRECT("C"&ROW())=1


0 Responses to “ Excel | Conditional row color based on a cell value”

  1. No Comments

Leave a Reply

You must login to post a comment.