S
SPM
Suppose Cell A1 = x, then I want to color B1 black
& when Cell A1 = y, then I want to color B1 blue
& when Cell A1 = y, then I want to color B1 blue
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
What version of Excel are you using?
Biff
Biff
D
David Biddulph
Format/ Conditional formatting/ Formula is ...
S
SPM
T
T. Valko
Try this:
Select cell A1
Goto the menu Format>Conditional Formatting
Condition 1
Formula Is: =A1="x"
Click the format button
Select the style(s) desired
OK
Click the Add button
Condition 2
Formula Is: =A1="y"
Click the format button
Select the style(s) desired
OK out
Biff
Select cell A1
Goto the menu Format>Conditional Formatting
Condition 1
Formula Is: =A1="x"
Click the format button
Select the style(s) desired
OK
Click the Add button
Condition 2
Formula Is: =A1="y"
Click the format button
Select the style(s) desired
OK out
Biff
G
Gord Dibben
To change B1 cell you must select B1(not A1) then follow Biff's post from
Condition1 onward using =A1="x" etc..
Gord Dibben MS Excel MVP
Condition1 onward using =A1="x" etc..
Gord Dibben MS Excel MVP
T
T. Valko
Ooops!
Biff
Biff
Gord Dibben said:To change B1 cell you must select B1(not A1) then follow Biff's post from
Condition1 onward using =A1="x" etc..
Gord Dibben MS Excel MVP
S
SPM
Thnx Boss. Got it. Doing fine. Thank you once again.