IF Formula for Changing Colour of Cell

[sunshine82]

Hello All and Happy Friday!!

I've got the following formula in a cell and need it to include if H3="In Progress", "Blue","Green". SO in another words just need the cell to turn blue if it says in progress in H3.

=IF(J3="","Green",IF(H3="Signed Off","Green",IF(J3<TODAY()+5,"Red",IF(J3<TODAY()+10,"Amber","Green"))))

Many thanks

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[sunshine82]

OK, hope it's OK now?

[ashishmehra2010]

Hi,

Try this =IF(J3="","Green",IF(H3="Signed Off","Green",IF(H3="In Progress","Blue",IF(J3<TODAY()+5,"Red",IF(J3<TODAY()+10,"Amber","Green")))))

Regards,
AM

[sunshine82]

Sorry didn't work :-(

[ashishmehra2010]

Hi Sunshine,

Try the attached file for your reference or post from your side.

Regards,
AM

[sunshine82]

Sorry I cannot download files due to firewalls and security. Do you mind showing the example on the post? Thanks :-)

[badincite]

What your after is conditional formatting

https://support.office.com/en-au/art...b-f1951ff89d7f

2cwq0ip.jpg

[sunshine82]

As far as my knowledge goes, conditional formatting will only format the cell with the "In Progress" in but I want the cell next to it to turn blue as thats the one that has the colours by status. Thanks

[badincite]

Probably a better way but why not make the cell beside it reference it and use conditional formatting to hide the value


Here's how http://chandoo.org/wp/2009/06/05/hide-cell/

[Ursul]

Changing Colour of Cell.xlsx

Have a look at the attached.

Cheers

[FDibbins]

Ursul, perhaps you missed post #7?

[FDibbins]

Sunshine, perhaps something like this...
1. highlight the range you want to apply the conditional formatting to (H3?)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$H3="In Progress" format fill as needed

You can create new rules with different criteria for all the options you have

[Ursul]

Thanks FDibbins - my bad!! LOL

[Ursul]

FDibbins - thanks exactly as I had it so thank you for posting it so it can be seen.

Screenshot.png

[FDibbins]

I figured thats what you had