Automatically shade cell dependant upon text in aother cell

[spoursy]

Hi,

Im writing a spreadsheet that will act as a hotel room booking diary.
There will be 52 sheets (representing each week of the year) and each sheet will therefore represent one week

Each sheet will look at operate the same. Running horizontally will be the days of the week and running vertically will be each of the bedrooms. There are 22 bedrooms in total and each room will have 12 cells allotted to it for each day - lets call this a 'block' and presume that the first block runs from C10 to c21. The final of these cells C21 will have a validation and the user can select 'PAID' 'TO PAY' or 'INVOICED'

If the user selects 'PAID' in C21 I want cells C10 through to C21 to shade GREEN
If the user selects 'TO PAY' in C21 I want cells C10 through to C21 to shade RED
If the user selects 'INVOICE' in C21 I want cells C10 through to C21 to shade YELLOW

Any idea how I can do this - Im starting to go CRAZY!!!!!!

[NBVC]

Select C10 to C21 and go to Format|Conditional Formatting

Select Formula Is from 1st drop down and enter formula: =$C$21="PAID"

Click Format and choose Green from the Pattern Tab.

Click Ok..

Click Add..

Select Formula Is and enter formula: =$C$21="TO PAY" and choose Red

Click Add and repeat with Formula =$C$21="INVOICE" adn choose Yellow..

[spoursy]

BRILLIANT ! I can go home now!

[NBVC]

Great, can you now please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save