Applying conditional formatting only if checkbox is checked

[Ken Johnson]

I am trying to apply conditional formatting to a cell only if a checkbox is checked. Any ideas?

 

[Vasant Nanavati]

Link the checkbox to a cell and use the cell value (TRUE/FALSE) as your
condition.

--

Vasant

I am trying to apply conditional formatting to a cell only if a checkbox

is checked. Any ideas?

 

[Dave Peterson]

give that checkbox a linked cell and include that in your check:

=and(a1=true,.....

where A1 is the linked cell.

 

[Ken Johnson]

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 am trying to apply conditional formatting to a cell only if a checkbo

is checked. Any ideas

 

[Vasant Nanavati]

Try using TRUE without the quotes.

--

Vasant

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)

 

[Ken Johnson]

BINGO! Thanks

----- Vasant Nanavati wrote: ----

Try using TRUE without the quotes

--

Vasan

A prayer to the EXCEL gods

checkbox linked to U5 giving me a true/false value and in another cell
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]

You're welcome. Just to clarify, "TRUE" is a string; TRUE is a Boolean
value. CElls linked to checkboxes assume Boolean values.

--

Vasant

BINGO! Thanks!

----- Vasant Nanavati wrote: -----

Try using TRUE without the quotes.

--

Vasant

A prayer to the EXCEL gods:

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) seem to
get it to work. Thanks. (TRUE/FALSE) as
your

condition. message

I am trying to apply conditional formatting to a cell only if a

checkbox
is checked. Any ideas?