ExcelBanter - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/181380-conditional-formatting.html)

Melissa

Conditional Formatting

Okay. I am needing to have a cells A, if the date entered is less than 90
days to be one color, and if it is greater than 90 days to be one color.
Please help.

FSt1

Conditional Formatting

hi
90 days less or greather than when? the current date????

Regards
FSt1

"Melissa" wrote:

Okay. I am needing to have a cells A, if the date entered is less than 90
days to be one color, and if it is greater than 90 days to be one color.
Please help.

FSt1

Conditional Formatting

sorry melissa
you never answered.
i'm here to help.

sorry
FSt1

"FSt1" wrote:

hi
90 days less or greather than when? the current date????

Regards
FSt1

"Melissa" wrote:

Okay. I am needing to have a cells A, if the date entered is less than 90
days to be one color, and if it is greater than 90 days to be one color.
Please help.

All times are GMT +1. The time now is 08:28 PM.