R
Reen
from conditional formula, how can i create a formula IF D20 <= E20, Then will
display tick. else will display, cross tick
display tick. else will display, cross tick
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.
M
Max
One play ..
In say, F20:
=IF(D20<=E20,"a","r")
Format F20 with "Marlett" font
In say, F20:
=IF(D20<=E20,"a","r")
Format F20 with "Marlett" font
G
Gord Dibben
You cannot do this using CF.
You would have to go to event code in my opinion.
Gord Dibben MS Excel MVP
You would have to go to event code in my opinion.
Gord Dibben MS Excel MVP
G
Gord Dibben
Very good Max.
I had some event code worked out that did the same thing but the in-cell formula
is easier for OP.
Gord
I had some event code worked out that did the same thing but the in-cell formula
is easier for OP.
Gord
M
Max
Thanks for compliments, Gord !