Hi Guys,
I need to make conditional format of cell so that have few conditions and colours at the same time.
a b
21% 5%
23% 24%
4% 3%
4% 9%
39% 45%
23% 27%
23% 26%
47% 52%
column B should be formatted at the same time with 2 conditions
1st condition: if value in b <= a, b should be red
2nd condition: if b-a>5, b should be green
if nothing of those, it should stay as it is.
I'm sending attached file.
Thanks!
Stevan
Bookmarks