Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Conditional Formating a column [Solved/Closed]

Report
-
 Ian -
Hello,

I wish to conditionally format a column depending on another columns date value in excel 2010

Column A has a target date and Column B has the completion date. I want column B to show red if target date is greater than completion date and green if it is less than or equal to completion date.

I have managened to do this to two corresponding cells but not the whole column




1 reply

Answer 1 / 1
Posts
1923
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 29, 2021
 143
Ian, Good morning.

The logic that you described is very unusual to be applied in this case.
It is opposed to the type of control that is done.
But given your exact request, do:

Select dates at column B
Conditional Format Menu
Using Formula

Rule 1
=A2>B2
Format; Fill: RED

Rule 2
=A2<=B2
Format; Fill: GREEN

OK

Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Report

Many thanks all sorted
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!