[jkf[_3_]]

hi all

i have a sheet that consists of 7 coloums and unlimited rows, i need to
colour a group of numbers so that when they appear they turn a certain
colour. tried to do it in conditional but this only allows me to use 3.

any help would be appreiciated.

jkf

[Pete_UK]

See your other post.

Pete

On Mar 23, 9:34*pm, "jkf" wrote:
hi all

i have a sheet that consists of 7 coloums and unlimited rows, i need to
colour a group of *numbers so that when they appear they turn a certain
colour. tried to do it in conditional but this only allows me to use 3.

any help would be appreiciated.

jkf

[Daniel Miz]

If you could provide a bit more information I might have a solution for you if I don't already do.

With conditional formatting, select all the applicable rows / columns and click Conditional Formatting New Rule

select 'Format only cells that contain' then do 'equals to' and put whatever value you need colured once appeared.


Fairly straight forward, I hope it helped you mate.