Conditional Format Logic

[Hypnopoison]

Hello
I am new to the forum and a novice with Excel so any help would be extremely appreciated

The problem I have is that I want to use conditional formats but my work computer only has Excel 2000. Since this restricts me to have a maximum of 3 x conditional formats I wanted to try and use a formula to apply the same colour text/shading for a number of conditions in one row.

I have attached some word docs containing some screen grabs of my spreadsheet and formulas. (I am using Excel 2007).

In the examples I have managed to set a specific number of cells (A6 to AG6) to turn the text to green when another specific cell (F6) shows the text "Approved"

I would like to tell the cell range (A6 to AG6) to turn green when the cell (F6) displays the text "Approved" or "Complete" or "On proof".

Is this possible and what would I need to enter into the formula box to achieve this? I have tried using 'AND' and 'OR' formulas but it keeps saying there is a problem. I am sure what I want is possible but I am just getting the formula muddled.

Can anyone help me? If I could keep the spreadsheet as 2007 it wouldn't be a problem but I have to use it in 2000 .... any help is much appreciated. Please remember that I am a novice and don't really know anothing about macros or VB etc.

Any help is mucho appreciated
Thank you

x

[teylyn]

Hello,

a few things:

- if you want help with Excel, please post Excel files, not screenshots.
- your attachments are rather large. An Excel file with the same content will be much smaller

I would like to tell the cell range (A6 to AG6) to turn green when the cell (F6) displays the text "Approved" or "Complete" or "On proof".

You can use conditional formatting with a formula using an OR() statement like this:

=OR($F$6="Approved",$F$6="Complete",$F$6="On proof")

Apply to A6 to AG6.

If you need further help, please post an Excel workbook with a data sample.

diolch yn fawr,

[DonkeyOte]

@Hypnopoison, welcome to the board.

Your original thread title fell foul of Rule 1 of the Forum RULES.

Given this was your first post I have on this occasion modified for you but please be sure to familiarise yourself with the Forum Rules going forward

Thanks in advance for your co-operation.

[Hypnopoison]

Hello

Thank you soooo much, that worked perfectly Note taken about the attachments and apologies for the title error. Lesson learnt, thank you