Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello -
I have two columns with different numbers in each. Let's call them column A and column B. When column B is greater than or equal to column A... I'd like to make it red. Unfortunately, I'm having trouble selecting multiple cells to apply this to. I can only make it work one at a time... or referencing a whole column to one number, rather than the other column. I keep getting the error message: "You cannot use a direct reference to a worksheet range in a conditional formatting formula. Change the reference to a single cell, or use the reference with a worksheet function, such as =SUM(A1:E5). Your help is greatly appreciated. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Conditional Formatting | Excel Worksheet Functions |