Previous Topic Next Topic

Changing font colour in a range based on criteria in another

Closed
Marshal - Apr 8, 2016 at 10:59 AM
 Blocked Profile - Apr 8, 2016 at 04:39 PM
Hello,

I am trying to change the font colour in a range of cell based on conditions i set in another range of cell.
How do i go about it, its giving me some hassles.
Thanks

Related:

1 response

Answer 1 / 1
Blocked Profile
Apr 8, 2016 at 04:39 PM
What you are trying to do is called COnditional Formatting. It is simple. See below examples:



Results in:



Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses