Conditional Formatting

Closed

MJones447 Posts 2 Registration date Friday 5 June 2015 Status Member Last seen 5 June 2015 - 5 Jun 2015 à 06:59
MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Contributor Last seen 3 July 2015 - 5 Jun 2015 à 07:23

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

Conditional Formatting
Excel clear formatting - Guide
Excel conditional formatting based on date - Guide
Conditional formatting based on another cell text - Excel Forum
Conditional formatting if cell contains text - Excel Forum
Conditional formatting between two values ✓ - Excel Forum

1 response

Réponse 1 / 1

MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Contributor Last seen 3 July 2015 69
5 Jun 2015 à 07:23

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

Similar discussions

Conditional Format Cells Based on Another Cell and Own Cell

Highlight cell if another cell contains specific text

How to use conditional format based on text?

Conditional Formatting - highlight overdue dates

Conditional formatting several cells risk register

Similar discussions

Subscribe To Our Newsletter!