Previous Topic Next Topic

Conditional Formatting

Closed
MJones447 Posts 2 Registration date Friday June 5, 2015 Status Member Last seen June 5, 2015 - Jun 5, 2015 at 06:59 AM
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Jun 5, 2015 at 07:23 AM
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 response

Answer 1 / 1
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Jun 5, 2015 at 07:23 AM
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
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses