Hello everyone,
In the following table i need to set conditional formatting in C9:
if cell value = D5 (color in red)
if cell value = E5 ( color in blue)
if cell value = F5 (color in yellow)
if cell value = G5 (color in orange)
if cell value = H5 (color in teal)
which means more than 3 criteria.
I tried all the answers given in this thread and others and couldnt solve , is it possible ???
Thank you !
In the following table i need to set conditional formatting in C9:
if cell value = D5 (color in red)
if cell value = E5 ( color in blue)
if cell value = F5 (color in yellow)
if cell value = G5 (color in orange)
if cell value = H5 (color in teal)
which means more than 3 criteria.
I tried all the answers given in this thread and others and couldnt solve , is it possible ???
Thank you !