Excel VBA/Formula

Closed
kennconese
Posts
1
Registration date
Monday March 31, 2014
Status
Member
Last seen
March 31, 2014
- Mar 31, 2014 at 05:39 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Mar 31, 2014 at 06:44 AM
I have a simple project in which a range of cells are needed to be in filled with color, based on the value on another cell.
example

if Cell A5 has a value of Complete, cells A1 to A4 will be color-filled with green.

i tried googling for solutions but still to no avail..

thank you, and hope for a reply..

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Mar 31, 2014 at 06:44 AM
USE CONDITIONAL FORMATTING

select A1:a4

conditional formatting
manage rules
use formulas
the formula is
=$A$5="complete"
applies to $A$1:$A$4
click ok
save the flle

now enter "complete" in A5 see what happens
0