Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, can Boolean logic be applied to conditional formatting?
I have a spreadsheet where I have used conditional formatting to have cell
change color under certain conditions. Is there a way to apply Boolean logic to the changing background color? Or is manually counting the cells the only option? Thanks, Peter |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, can Boolean logic be applied to conditional formatting?
I'm not sure what you want to do with the background color. Can you explain
it differently? "PeterL" wrote: I have a spreadsheet where I have used conditional formatting to have cell change color under certain conditions. Is there a way to apply Boolean logic to the changing background color? Or is manually counting the cells the only option? Thanks, Peter |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, can Boolean logic be applied to conditional formatting?
No you can not count colours generated by a conditional foramt. You can
however use the logic of the conditional format along with either a sumproduct or an array formula to generate the count... Check out this link on sumproduct. There is also a discussion about counting colours at this web site... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "PeterL" wrote: I have a spreadsheet where I have used conditional formatting to have cell change color under certain conditions. Is there a way to apply Boolean logic to the changing background color? Or is manually counting the cells the only option? Thanks, Peter |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, can Boolean logic be applied to conditional formatting?
This function may be of use to you
Function CFCount(rng) Dim rng As Range Dim cc As Range Set rng = ActiveSheet.UsedRange i = 0 For Each cc In rng If cc.FormatConditions.Count 0 Then i = i + 1 'this cell has conditional formatting ' so handle it here End If Next CFCount = i End Function "PeterL" wrote: I have a spreadsheet where I have used conditional formatting to have cell change color under certain conditions. Is there a way to apply Boolean logic to the changing background color? Or is manually counting the cells the only option? Thanks, Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Conditional Formatting color multiple cells for 1 logical | Excel Worksheet Functions | |||
Excel Conditional Formatting - Two Dates Comparison | Excel Discussion (Misc queries) | |||
How do I display all conditional formatting in Excel? | Excel Worksheet Functions | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
EXCEL 2003: Apply Conditional Formatting to COLUMNS | Excel Worksheet Functions |