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
Format Cells - Fill colour Help 11
Calculations based on cell colour 9
How to auto text colour change to green if logical function true? 1
Cell formats 2
Copy addition formula of non-consecutive horizontal cells 2
Using CF to change colour in cell based on date? 4

Top