Setting conditional colours for cells

L

Loosey

Hi all, I have used the max 3 conditional formatting choices for setting cell
colours dependant upon value, but I need additional options.
I thisnk this can be done using macros but does anyone know the
formula/script?

My request is simple, I need all cells with H or H/2 to be yellow, U or U/2
to be red, & L or L/2 to be green (these have been set via conditional
formatting) however I also need V & V/2, F & F/2 and C & C/2 to have colour
formatting which I cannot apply without some manual formatting.

All help would be greatly appreciated :)
Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with VBA 4
ASK Field Formatting 1
Count Conditional Formatting Colours - Excel 2003 4
Colorindex and conditional formatting 2
Conditional Formatting and VBA 4
Cumulative formula for word table 0
conditional formating in adjacent cells 2
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1

Top