Results 1 to 3 of 3

Thread: Colour changeing cells

  1. #1

    Colour changeing cells

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is there a way to change a colour of a cell by entering text example I want to say if a1=tl then change cells a1 b1 and c1 to red

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Excel Version
    select Cell A1 then follow below step:

    Go to Home>Conditional Formatting>New Rule>choose "use a formula to determine which cell to format">put formula =A1="TL">Then go to format>click on Fill Tab>select Red Colour>click OK

    simirarly select B1 & C1 cell then follow above step.

    pl find attached book.xlsx
    Attached Files Attached Files

  3. #3
    Thank you very much

Posting Permissions

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