Results 1 to 3 of 3
  1. #1
    2 Star Lounger AlanWade's Avatar
    Join Date
    Dec 2009
    Location
    Sweden
    Posts
    109
    Thanks
    12
    Thanked 3 Times in 3 Posts

    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
    Alan

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Alan,

    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.
    cf.JPG
    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    AlanWade (2014-05-21)

  4. #3
    2 Star Lounger AlanWade's Avatar
    Join Date
    Dec 2009
    Location
    Sweden
    Posts
    109
    Thanks
    12
    Thanked 3 Times in 3 Posts
    Perfect and simple!
    Thanks very much RG

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •