My spreadsheet contains 3 columns. A - Number, B - Number, C - User Input (either left blank or "X"). I can conditionally format column B based on if B>20 (fills it red). I want to change the color to green if there is an X in the C cell next to it.
Example:
A B C
1 12-0011212 21
2 12-0015212 30 X
3 12-0015881 15
In the example, B1 would be filled Red
B2 would be filled Green
B3 would be no fill
Thanks!
Richard
Bookmarks