Conditional Formatting

Closed

BWitham5 Posts 3 Registration date Thursday March 22, 2018 Status Member Last seen April 6, 2018 - Apr 5, 2018 at 04:24 PM
Blocked Profile - Apr 6, 2018 at 06:47 PM

I have cell G8 in excel which is a time stamp. I want it to be highlighted when it is greater than cell A8 which is a scheduled time.

Conditional Formatting
How to clear formatting in excel - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum
Excel formula to change cell color without conditional formatting - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Phone formatting software for pc - Download - File management

2 responses

Answer 1 / 2

Blocked Profile
Apr 5, 2018 at 04:52 PM

Ok, what part are stuck with, the formula or the coloring?

BWitham5 Posts 3 Registration date Thursday March 22, 2018 Status Member Last seen April 6, 2018
Apr 6, 2018 at 12:55 PM

The formula

Answer 2 / 2

Blocked Profile
Apr 6, 2018 at 06:47 PM

In the formula bar of the rule, place the following:


=G8>A8

Here is an example:

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

one cell will turn green when the two other cells match

Conditional formating - apply on more cells

Similar discussions

Subscribe To Our Newsletter!