Hello,
I'm using numerical values to identify the status of projects as 1-completed/ 2-awaiting approval/ 3-requires attention (problem)
I wish to use conditional formatting so that all the cells in a row associated with a project is colored according to the numerical "status" value attributed (green-1, yellow-2, red-3)
I'm able to use conditional formatting so that the cell containing the numerical value is colored, but I don't know how (if it is possible ) to color the other cells in the row according to that numerical value.
The attachment uses the same disposition as the actual spreadsheet.
My goal would be that when I enter let's say "1" in F8, B8 to G8 are colored green.
Sorry if this has already been posted, I couldn't find the answer
Thanks!
Bookmarks