Previous Topic Next Topic

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

Answer 1 / 1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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