#1
|
|||
|
|||
How to change the colour of a cell
eg if cell A1=5 then change the colour of cell A1 to green.
Has anyone got any examples of such a formula? Regards Goozzie |
#2
|
||||
|
||||
Hi
hit F1 and search for " conditional formatting"
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Solved
Thanks Pecoflyer
|
#4
|
||||
|
||||
Most welcome
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change Text Colour in Cell Based on Text in Same Cell | PMC11 | Word VBA | 1 | 11-14-2017 09:15 PM |
Change of colour of Email | mravimtnl | Outlook | 2 | 04-03-2017 02:10 AM |
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow | FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
VBA to immediately change the colour of a cell depending on the code placed in anothe | Phil Payne | Excel Programming | 2 | 07-27-2013 11:04 PM |
CHange colour of footer if a cell changes to red | OTPM | Excel | 0 | 05-26-2011 07:15 AM |