Hi,
I am beginner in excel. Need help
So how can i fill the cell with a different colour. Based on the input
my input
Example : If A5 = 1, D5 = 6 : Cell D5 Should get fill with Yellow
If value changes A5 = 2, D5 = 6 : Cell D5 should remain white
If A5 =3, D5 = 7, Cell D5 should be fill with RED colour
I know the conditional format . but It only returns True and False.(not wokring)
Capture.JPG
Thanks
Bookmarks