C Chris Moore Oct 19, 2009 #1 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 Oct 19, 2009 #2 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
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
