Excel Worksheet with Macro and Conditional Formatting

Imekamilika Ilichapishwa Feb 16, 2015 Kulipwa wakati wa kujifungua

$10-30 USD

Kulipwa wakati wa kujifungua

Imekamilika Kulipwa wakati wa kujifungua

I just want to show my Manager that it can be done using by both conditional formatting and Macro.

My main motive is that in the Home tab of the spreadsheet in front of Job 1 there is red color it should change to green when I delete all the validate text in Job 1 tab and if I retype validate again in Job 1 the color of the cell should turn to red again.

So basically I want it to search the whole sheet for the word 'VALIDATE' if it does not find it red should turn to green and if there in nothing in Job 1 tab and if I type VALIDATE in any cell the green color should change to red again.

Uingizaji Data Kutengeneza Data Excel

Kitambulisho cha Mradi: #7153262

Kuhusu mradi

3 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya P0L
P0L

Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD kwa siku 1
(Maoni 35)
4.9

3 wafanyakazi huru wanazabuni wastani wa $30 kwa kazi hii

Picha ya Profaili ya zExcel
zExcel

A proposal has not yet been provided

$34 USD kwa siku 0
(Maoni 146)
6.8
Picha ya Profaili ya renesontiongson
renesontiongson

Hi! excel automation is my masterpiece in my accounting field. It is my pleasure to help your project feel free to message me with your actual data. Thank you.

$25 USD kwa siku 1
(Maoni 13)
3.1
Tuma Mradi Kama huu