Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format a cell based on another range of cells
I am trying to format cell "A" to have a fill color IF cells b3-aq3 have a
date less than today's date. I entered this formulaL: =$b$3:$aq$5<=(NOW()). but for some reason it's only formatting based on the value in b3 rather than any of the cells in the range. any help woul be greatly appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format a cell based on another range of cells
Try
=COUNTIF($B$3:$AQ$5,"<="&NOW())0 Regards, Peo Sjoblom ked wrote: I am trying to format cell "A" to have a fill color IF cells b3-aq3 have a date less than today's date. I entered this formulaL: =$b$3:$aq$5<=(NOW()). but for some reason it's only formatting based on the value in b3 rather than any of the cells in the range. any help woul be greatly appreciated! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format a cell based on another range of cells
Peo
Thank you - it worked - now can you tell me if there is a way to copy this CF to other cells as I have a bunch to do this with. Thanks, KED "Peo Sjoblom" wrote: Try =COUNTIF($B$3:$AQ$5,"<="&NOW())0 Regards, Peo Sjoblom ked wrote: I am trying to format cell "A" to have a fill color IF cells b3-aq3 have a date less than today's date. I entered this formulaL: =$b$3:$aq$5<=(NOW()). but for some reason it's only formatting based on the value in b3 rather than any of the cells in the range. any help woul be greatly appreciated! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format a cell based on another range of cells
Select all the cells, and then assuming row 3 is first select row, use
=COUNTIF($B3:$AQ3,"<="&NOW())0 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "ked" wrote in message ... Peo Thank you - it worked - now can you tell me if there is a way to copy this CF to other cells as I have a bunch to do this with. Thanks, KED "Peo Sjoblom" wrote: Try =COUNTIF($B$3:$AQ$5,"<="&NOW())0 Regards, Peo Sjoblom ked wrote: I am trying to format cell "A" to have a fill color IF cells b3-aq3 have a date less than today's date. I entered this formulaL: =$b$3:$aq$5<=(NOW()). but for some reason it's only formatting based on the value in b3 rather than any of the cells in the range. any help woul be greatly appreciated! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format a cell based on another range of cells
Thank You!
"Bob Phillips" wrote: Select all the cells, and then assuming row 3 is first select row, use =COUNTIF($B3:$AQ3,"<="&NOW())0 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "ked" wrote in message ... Peo Thank you - it worked - now can you tell me if there is a way to copy this CF to other cells as I have a bunch to do this with. Thanks, KED "Peo Sjoblom" wrote: Try =COUNTIF($B$3:$AQ$5,"<="&NOW())0 Regards, Peo Sjoblom ked wrote: I am trying to format cell "A" to have a fill color IF cells b3-aq3 have a date less than today's date. I entered this formulaL: =$b$3:$aq$5<=(NOW()). but for some reason it's only formatting based on the value in b3 rather than any of the cells in the range. any help woul be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format if cell match found in another range of cells | Excel Worksheet Functions | |||
Conditional Format based on range | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) |