G
Guest
I am trying to apply conditional formatting to a cell only if a checkbox is checked. Any ideas?
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.
V
Vasant Nanavati
Link the checkbox to a cell and use the cell value (TRUE/FALSE) as your
condition.
--
Vasant
condition.
--
Vasant
is checked. Any ideas?Ken Johnson said:I am trying to apply conditional formatting to a cell only if a checkbox
D
Dave Peterson
give that checkbox a linked cell and include that in your check:
=and(a1=true,.....
where A1 is the linked cell.
=and(a1=true,.....
where A1 is the linked cell.
G
Guest
A prayer to the EXCEL gods
I've been working on this conditional format for way too long. I have a checkbox linked to U5 giving me a true/false value and in another cell I have a numerical value. I am trying to conditional format the numerical value cell by using an AND statement in condition 1. Here's how it reads Formula is =AND($U$5="TRUE", $F$5>14
I am not getting an error message with that formula, but I can't seem to get it to work. Thanks.
----- Vasant Nanavati wrote: ----
Link the checkbox to a cell and use the cell value (TRUE/FALSE) as you
condition
--
Vasan
I've been working on this conditional format for way too long. I have a checkbox linked to U5 giving me a true/false value and in another cell I have a numerical value. I am trying to conditional format the numerical value cell by using an AND statement in condition 1. Here's how it reads Formula is =AND($U$5="TRUE", $F$5>14
I am not getting an error message with that formula, but I can't seem to get it to work. Thanks.
----- Vasant Nanavati wrote: ----
Link the checkbox to a cell and use the cell value (TRUE/FALSE) as you
condition
--
Vasan
is checked. Any ideasKen Johnson said:I am trying to apply conditional formatting to a cell only if a checkbo
V
Vasant Nanavati
Try using TRUE without the quotes.
--
Vasant
have a numerical value. I am trying to conditional format the numerical
value cell by using an AND statement in condition 1. Here's how it reads
Formula is =AND($U$5="TRUE", $F$5>14)
--
Vasant
checkbox linked to U5 giving me a true/false value and in another cell IKen Johnson said:A prayer to the EXCEL gods:
I've been working on this conditional format for way too long. I have a
have a numerical value. I am trying to conditional format the numerical
value cell by using an AND statement in condition 1. Here's how it reads
Formula is =AND($U$5="TRUE", $F$5>14)
G
Guest
BINGO! Thanks
----- Vasant Nanavati wrote: ----
Try using TRUE without the quotes
--
Vasan
have a numerical value. I am trying to conditional format the numerica
value cell by using an AND statement in condition 1. Here's how it read
Formula is =AND($U$5="TRUE", $F$5>14
----- Vasant Nanavati wrote: ----
Try using TRUE without the quotes
--
Vasan
checkbox linked to U5 giving me a true/false value and in another cellKen Johnson said:A prayer to the EXCEL gods
have a numerical value. I am trying to conditional format the numerica
value cell by using an AND statement in condition 1. Here's how it read
Formula is =AND($U$5="TRUE", $F$5>14
V
Vasant Nanavati
You're welcome. Just to clarify, "TRUE" is a string; TRUE is a Boolean
value. CElls linked to checkboxes assume Boolean values.
--
Vasant
value. CElls linked to checkboxes assume Boolean values.
--
Vasant
Ken Johnson said:BINGO! Thanks!
----- Vasant Nanavati wrote: -----
Try using TRUE without the quotes.
--
Vasant
have aKen Johnson said:A prayer to the EXCEL gods:
checkbox linked to U5 giving me a true/false value and in another cell I
have a numerical value. I am trying to conditional format the numerical
value cell by using an AND statement in condition 1. Here's how it reads
Formula is =AND($U$5="TRUE", $F$5>14) seem to
get it to work. Thanks. (TRUE/FALSE) as
yourcondition. message
checkboxI am trying to apply conditional formatting to a cell only if a
is checked. Any ideas?