Conditonal formating

[shiraz50]

Hi

Please can you help me with a formula

All of this conditional formatting is for column A on a pivot table.

• If Column A is less than today = red.
• If Column A is > than today = Green
• If Column A is = "No Notice" than today = Yellow

 

[SanjayGMusafir]

You have to use 3 separate Formula rules for the purpose. Check this and revert -

If Column A is less than today = red.

=A1<Today()

If Column A is > than today = Green

=A1>Today()

If Column A is = "No Notice" than today = Yellow

=A1="No Notice"

 

[shiraz50]

Hi

Sorry i need the formula in conditional formula method

 

[SanjayGMusafir]

Hi

Sorry i need the formula in conditional formula method

Check the thread #2 I gave the same - I told you you need 3 separate formulae