Home |
Search |
Today's Posts |
#1
|
|||
|
|||
checkbox for condtn'l formatting mod(row(),2)
I've used the mod(row(),2) conditional formatting on a spreadsheet and need
to create a checkbox so iusers can turn it on and/or off. What would the formula be in the conditional formatting dialog box to make this happen??? Many thanks, as always, Marika :) |
#2
|
|||
|
|||
Hi!
Link the checkbox to a cell and then include a reference to that cell in your conditional formatting formula. Assume you link the checkkbox to cell B1. When "checked" cell B1 will return the value TRUE. When "unchecked" B1 will return the value FALSE. You can hide the TRUE or FALSE by setting the text color to be the same as the fill color. When someone checks or unchecks the checkbox, it will turn on or off the conditional formatting. Use something like this for the cf formula: =AND(B1=TRUE,Your_CF_formula_Here) Biff -----Original Message----- I've used the mod(row(),2) conditional formatting on a spreadsheet and need to create a checkbox so iusers can turn it on and/or off. What would the formula be in the conditional formatting dialog box to make this happen??? Many thanks, as always, Marika :) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell formatting behaviour question | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |