LinkBack URL
About LinkBacks
Dear Community
I have got in a cell a tick and cross using P and O under Wingdings2 font.
I would like that if a tick comes up, it is in green and if a cross it is in red.
How would I write a formula to get this conditional formatting please?
Thanks
Dear Community
I have got in a cell a tick and cross using P and O under Wingdings2 font.
I would like that if a tick comes up, it is in green and if a cross it is in red.
How would I write a formula to get this conditional formatting please?
Thanks
use cf of cell value = to p choose green
same for red
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I tried the following
Highlight Cell Rules
Equal To
=P
Format
NOTHING HAPPENS
it should look like this ="p" mind you i'd use martlet a and r as not everyone has windings 2
heres an example
Last edited by martindwilson; 07-19-2012 at 09:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks