Excel | Conditional row color based on a cell value
Published July 15th, 2006 in geeks only, business.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”
Please Wait
Leave a Reply
You must login to post a comment.