Results 1 to 3 of 3
2014-05-21, 13:08 #1
Conditional Formula To Change Font Colour
What I am struggling to acheive with a conditional formula is if I enter "2" ia cell then all of that row will have red text, e.g. B11,C11,D11 etc.
Basically want I want to acheive is if I enter a "1" then its just black text as it is now but if I enter a "2" it changes colour. This is in a time sheet and will help me to identify when I work a bank holiday easily.
Thanks for any help
2014-05-21, 13:31 #2
- Join Date
- Mar 2004
- Manning, South Carolina
- Thanked 1,510 Times in 1,371 Posts
This should do the trick. Note that once you have it entered you can select the cells in the last row the CF is applied to then just copy down in Col B to increase the range or just change the apply to range to include the last row desired.
The Following User Says Thank You to RetiredGeek For This Useful Post:
2014-05-21, 13:47 #3
Perfect and simple!
Thanks very much RG