formula to change cell colour

C

Chris Moore

I would like to colour a cell of the one I am looking at i.e. change cell CF6
to black if BF6="GAL".
 
J

Jacob Skaria

You can try conditional formatting

1. Select the cell CF6
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula

=BF6="GAL"

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove colour change 4
Changing coloue cell en text colour by clicking cell 3
Conditional formatting in Excel 2010 2
Calculations based on cell colour 6
cell colour 4
Question about conditional formatting of zeros in Excel 0
Using CF to change colour in cell based on date? 4
Conditional Formatting - Excel 2003 2

Top