Conditional formatting & formuals

  • Thread starter Thread starter paulJJ
  • Start date Start date
P

paulJJ

Apologies if there is an obvious answer to this....


I want to format a row of cells a particular colour if in, for example,
when you enter the letters "GM" in cell E19 it turns the row (E) to
blue and if you enter "GF" in cell E19 the row turns to red , etc etc

I guess i might need to use the IF(ISTEXT) function ??? but can't quite
seem to get it right any ideas ??
 
Hi
try the following
- select the entire row 19
- goto 'Format - conditional format'
- enter the following formula:
=$E19="GM"
- choose your format (blue)
- add a new condition and enter the formula:
=$E19="GF" (and choose the format 'red')

Note: you can only use 3 different conditions like this (+ the default
format of your row). For more info have a look at
http://www.contextures.com/xlCondFormat01.html

Frank
 
Just a thought, if this is to cover more rows than just 19, you need some
changes.

Select all the rows (assume 19 as first, but amend to suit)
Use formulae of
=$E19 = "GM"
=$E19 = "GF"

Note the $ numbers and positions

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top