Conditional Formatting Table Row Colour\Color

[StuartSmith]

Is there a way to format table rows so that say if the row had "Closed" in the "Office Status" column, the row is "Red", but if the Office Status" is "Open", then then the row is green?

[luapdoniv]

Create a custom column to mark the open status as 1 and closed as 0.
Then apply conditional formatting based on rules to set the background color for each of the cols based on the value in the new column

[StuartSmith]

Thanks, not overly familiar with custom columns, so struggling with the code.

Guess it would be something like

Office_Status_Custom_Column = IF(Sheet1[Office Status] = "Closed"), "0"), IF(Sheet1[Office Status] = "Open"), "1"), IF(Sheet1[Office Status] = "Other"), "2")

But cant figure it out, any guidence would be great.

[luapdoniv · Accepted solution]

Office_Status_Custom_Column = IF(Sheet1[Office Status] = "Closed", 0, IF(Sheet1[Office Status] = "Open", 1, 2))

[StuartSmith]

Thanks 👍