Conditional Formatting [Closed]

Report
Posts
2
Registration date
Friday June 5, 2015
Status
Member
Last seen
June 5, 2015
-
MaxStart
Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
-
I have a document in excel where I want to change the colour of a number of cells based on information in one. So I'm guessing a formula will be needed. Basically if i choose complete from a drop down list then I want that cell plus the 4 cells before it to turn green. At the moment I can only get the one cell with specific text to change.

Many Thanks

1 reply

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
53
Hey there !!
this subject has been discussed many time here;
please check this search n Kioskea

you can also visit these solved topics:
Conditional Formatting: 3 range of numbers
Cell format