Posted to microsoft.public.excel.newusers
|
|
If, And, Or ...or something else
orait!...many thanks :-)
"Bernard Liengme" wrote:
1) Select C7 and D7
2) Hold CTRL and select G7
3) Open Conditional Formatting dialog, use Formula IS =$G$7="a"
and set colour
4) Add second condition with =$G$7="b", etc
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"KoE" wrote in message
...
I would like to have, say:
cells C7 & D7 to turn into red when G7="a"; blue when G7="b"; yellow when
G7="c". Cells C7 & D7 are constant; only G7 changes. This will go on with
the
following rows.
I've downloaded and read the sample from office online help but the
closest
I could find was "shadow an entire row when several criteria must be true"
but I can't emulate the formula into mine.
|