Hi everyone;
i'm trying to change the colour of cells based on the text in a certain cell, for example if the cell has the word
Good in it then change the colour to green
Sat change colour to yellow and
Poor red.
the psudoe code is this i think if cell = to Good change cell background colour to green, if cell= equal to Sat change cell background colour to yellow.
But can anyone help me translating this into actual If statement which Excel understands?
Please i really need your help.
Thanks you
Mark
Bookmarks